SELECT p.iPostID, p.iPostType, p.iAdType, p.iUserType, p.strTitle, p.iSubType, p.iItemType, p.iPrice, p.iPriceUnit, json_unquote(p.jsonLocation->"$.city") AS city, p.jsonExtra, p.tmPosted, p.iShowImg, p.strImages, p.strVideos, p.strPostURL FROM posts p WHERE p.iActive=1 AND p.iPostType=3 AND iPostID IN (SELECT t.iPostID FROM posttext t WHERE t.iDomID=1 AND MATCH (t.strSearch) AGAINST ('+looking +for +the +jobs' IN BOOLEAN MODE)) AND iCityID IN (6573,6402,6463,6448,6547,6649,16574,6430,6615,6609,6629,6405,6503,6386,6548,6624,6361,6449,3004,3063,6626,6408,6560,6474,6420,2982,6522,16534,6512,6520,6597,6313,2843,2802,6359,16626,6341,6336,6424,16240,16533,6323,6421,2796,6588,6307,6484,6350,3023,3003,2785,6485,2978,6572,3045,6656,6545,2878,6316,2823,2847,6312,2884,2882,3048,6511,6498,2886,514,2822,2928,6613,6496,6601,6644,2980,6579,6641,6494,2870,6348,3076,3011,2773,2968,512,6434,6510,2890,3041,6345,516,3026,16228,6578,515,6349,3056,2927,2875,6540,2943,513,16654,6459,2824,6438,2825,6471,6497,6460,6499,3078,2938,6303,2987,6487,6452,6321,2830,2766,2911,6549,2971,16191,6473,6652,2793,2827,2887,2835,2919,2832,3064,2871,2831,16460,16213,2865,3050,16197,2786,3016,6650,2991,2858,7,6564,2853,2912,2804,6542,2956,6395,3040,16220,2821,6569,2784,2842,2866,6475,2808,2834,2896,2781,3002,3058,16253,3035,3054,2936,2800,2937,3081,2877,3066,2765,6526,2974,2874,16129,6537,2897,3068,2910,3071,2848,2939,2881,2799,16507,2889,2806,2969,2892,6501,16242,2872,3034,3033,2764,3052,3005,2921,3049,16196,2828,2798,6406,2934,6368,2981,2941,2942,2891,3018,2777,2797,6514,2929,2924,3082,6622,2778,2958,3075,2970,2963,3051,3032,6633,16504,6776,2782,16224,2876,2873,16506,16532,3024,3067,16505,2794,2791,2967,2792,2957,2833,21,2788,6672,16232,3028,2946,16194,3065,16252,2826,3055,2839,2965,2955,6311,2837,2986,6681,6319,2862,3069,6766,2905,2932,3037,2904,2920,2859,6325,3070,2883,2774,2861,6603,2844,2810,2973,3083,6592,2769,2813,2840,3047,3010,2966,2947,6777,2851,2869,2852,2926,2888,2787,3080,6309,3015,2940,2922,2770,3009,2975,2908,2948,2776,2994,2856,2914,2950,2795,2990,3038,2885,2998,2989,2993,2771,16535,3012,3036,2895,2845,3020,2960,2775,6425,2772,2815,3059,3039,2913,2768,3074,2917,16214,6437,2801,2816,6717,2916,6554,6436,6647,3029,3019,6394,2935,2976,6733,6635,2817,6608,2850,2807,3057,2811,2893,2962,3042,2961,6481,3021,6392,2953,3061) ORDER BY FIELD(iCityID, 6573,6402,6463,6448,6547,6649,16574,6430,6615,6609,6629,6405,6503,6386,6548,6624,6361,6449,3004,3063,6626,6408,6560,6474,6420,2982,6522,16534,6512,6520,6597,6313,2843,2802,6359,16626,6341,6336,6424,16240,16533,6323,6421,2796,6588,6307,6484,6350,3023,3003,2785,6485,2978,6572,3045,6656,6545,2878,6316,2823,2847,6312,2884,2882,3048,6511,6498,2886,514,2822,2928,6613,6496,6601,6644,2980,6579,6641,6494,2870,6348,3076,3011,2773,2968,512,6434,6510,2890,3041,6345,516,3026,16228,6578,515,6349,3056,2927,2875,6540,2943,513,16654,6459,2824,6438,2825,6471,6497,6460,6499,3078,2938,6303,2987,6487,6452,6321,2830,2766,2911,6549,2971,16191,6473,6652,2793,2827,2887,2835,2919,2832,3064,2871,2831,16460,16213,2865,3050,16197,2786,3016,6650,2991,2858,7,6564,2853,2912,2804,6542,2956,6395,3040,16220,2821,6569,2784,2842,2866,6475,2808,2834,2896,2781,3002,3058,16253,3035,3054,2936,2800,2937,3081,2877,3066,2765,6526,2974,2874,16129,6537,2897,3068,2910,3071,2848,2939,2881,2799,16507,2889,2806,2969,2892,6501,16242,2872,3034,3033,2764,3052,3005,2921,3049,16196,2828,2798,6406,2934,6368,2981,2941,2942,2891,3018,2777,2797,6514,2929,2924,3082,6622,2778,2958,3075,2970,2963,3051,3032,6633,16504,6776,2782,16224,2876,2873,16506,16532,3024,3067,16505,2794,2791,2967,2792,2957,2833,21,2788,6672,16232,3028,2946,16194,3065,16252,2826,3055,2839,2965,2955,6311,2837,2986,6681,6319,2862,3069,6766,2905,2932,3037,2904,2920,2859,6325,3070,2883,2774,2861,6603,2844,2810,2973,3083,6592,2769,2813,2840,3047,3010,2966,2947,6777,2851,2869,2852,2926,2888,2787,3080,6309,3015,2940,2922,2770,3009,2975,2908,2948,2776,2994,2856,2914,2950,2795,2990,3038,2885,2998,2989,2993,2771,16535,3012,3036,2895,2845,3020,2960,2775,6425,2772,2815,3059,3039,2913,2768,3074,2917,16214,6437,2801,2816,6717,2916,6554,6436,6647,3029,3019,6394,2935,2976,6733,6635,2817,6608,2850,2807,3057,2811,2893,2962,3042,2961,6481,3021,6392,2953,3061) ASC, p.tmPosted DESC LIMIT 24 OFFSET 48 looking for the jobs, Job Classifieds, IT Jobs, Sales Jobs, Employers, Freelancers, Work from Home in Reston, Page 3

Job classifieds in Reston - looking for the jobs

Show more results

By Using this website, you agree to Terms of Use & Privacy Policy. Got it